@echo off


set MYSQL_BIN_PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin

set PATH=%MYSQL_BIN_PATH%;%PATH%

set USER_NAME="root"

set PASSWORD="root"

set SCHEMA_NAME="expweb"



mysqladmin -u %USER_NAME% -p%PASSWORD% drop %SCHEMA_NAME%

mysqladmin -u %USER_NAME% -p%PASSWORD% create %SCHEMA_NAME%



echo "update database, please wait..."

echo "createTable.sql"
mysql -u %USER_NAME% -p%PASSWORD% %SCHEMA_NAME%<createTable.sql

cmd